// --------------------------------------------------------------------------------------------------------------------
// <copyright file="SqlCompareOptionsGenerated.cs" company="SmartPlan">
//   SmartPlan 2011
// </copyright>
// <summary>
//   SqlServer Compare Options
// </summary>
// --------------------------------------------------------------------------------------------------------------------

namespace DbDiff.Common.Comparer
{
    using System;
    using System.Linq;
    using System.Runtime.Serialization;
    using System.Xml;
    using Helper;

    /// <summary>
    /// SqlServer Compare Options
    /// </summary>
    [DataContract]
    public class SqlCompareOptions
    {
        #region Fields & properties

        /// <summary>
        /// Gets or sets CompareOptionsList.
        /// </summary>
        [DataMember]
        public CompareOptionList CompareOptionsList { get; set; }

        #endregion Fields & properties

        #region Constructors

        /// <summary>
        /// Initializes a new instance of the <see cref="SqlCompareOptions"/> class. 
        /// Creates a new <see cref="SqlCompareOptions"/> instance.
        /// </summary>
        public SqlCompareOptions()
        {
            // this.SqlVersion = SqlVersion.Sql2K ;
            this.CompareOptionsList = new CompareOptionList();
            this.ResetToDefault();
        }

        #endregion Constructors

        /// <summary>
        /// Resets to default.
        /// </summary>
        public void ResetToDefault()
        {
            // fill compareoptions-t with default values
            this.CompareOptionsList.Clear();
            var param = new CompareOptionParams
                            {
                                Name = "IsCompareUnderScored",
                                Value = "false",
                                CompareOptionType = OptionType.Misc,
                                ErrorMsgId = string.Empty,
                                TableName = string.Empty,
                                ToolTip = string.Empty,
                                Label = "Compare object if begin with '_'",
                                ErrorMessage = string.Empty,
                                ControlledBy = string.Empty,
                                Visible = "True",
                                Reload = "True",
                                Recompare = "True",
                                CompareOptionControlType = CompareOptionControlType.CheckBox,
                                UserInterfaceType = "General",
                                RowNumber = 0
                            };

            this.CompareOptionsList.Add(new CompareOption(param));

            #region QueryTimeOut OptionType.Misc RowNumber=1

            param.Name = "QueryTimeOut";
            param.Value = "60";
            param.CompareOptionType = OptionType.Misc;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Timeout";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.TextBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 1;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion QueryTimeOut OptionType.Misc RowNumber=1	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region DebugMode OptionType.Misc RowNumber=2

            param.Name = "DebugMode";
            param.Value = "True";
            param.CompareOptionType = OptionType.Misc;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "False";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = string.Empty;
            param.RowNumber = 2;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion DebugMode OptionType.Misc RowNumber=2	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsShowOnlyDifferent OptionType.Misc RowNumber=3

            param.Name = "IsShowOnlyDifferent";
            param.Value = "true";
            param.CompareOptionType = OptionType.Misc;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Show only different objects";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "False";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 3;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsShowOnlyDifferent OptionType.Misc RowNumber=3	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region ObjectName OptionType.Misc RowNumber=4

            param.Name = "ObjectName";
            param.Value = string.Empty;
            param.CompareOptionType = OptionType.Misc;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = "Object name";
            param.Label = "Object name";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "True";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.TextBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 4;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion ObjectName OptionType.Misc RowNumber=4	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region CompileMode OptionType.Misc RowNumber=5

            param.Name = "CompileMode";
            param.Value = "true";
            param.CompareOptionType = OptionType.Misc;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "False";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = string.Empty;
            param.RowNumber = 5;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion CompileMode OptionType.Misc RowNumber=5	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsCaseSensitive OptionType.Misc RowNumber=6

            param.Name = "IsCaseSensitive";
            param.Value = "false";
            param.CompareOptionType = OptionType.Misc;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Case sensitive";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "True";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 6;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsCaseSensitive OptionType.Misc RowNumber=6	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsIgnoreOptions OptionType.Misc RowNumber=7

            param.Name = "IsIgnoreOptions";
            param.Value = "false";
            param.CompareOptionType = OptionType.Misc;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Ignore all compare option";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "True";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 7;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsIgnoreOptions OptionType.Misc RowNumber=7	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsCompareEmail OptionType.Misc RowNumber=8

            param.Name = "IsCompareEmail";
            param.Value = "false";
            param.CompareOptionType = OptionType.Misc;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = "Compare email addr. in sp,view etc";
            param.Label = "Compare email addr. in sp,view etc";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 8;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsCompareEmail OptionType.Misc RowNumber=8	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region SchemaName OptionType.Misc RowNumber=9

            param.Name = "SchemaName";
            param.Value = string.Empty;
            param.CompareOptionType = OptionType.Misc;
            param.ErrorMsgId = string.Empty;
            param.TableName =
                "Check@Default@DefaultCnst@Details@Fields@Foreign@ForeignKey@Function@Index@IndexKey@Procedure@Rule@Table@Trigger@UDT@View";
            param.ToolTip = string.Empty;
            param.Label = "Schema name";
            param.ErrorMessage = "Schema name";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "True";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.TextBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 9;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion SchemaName OptionType.Misc RowNumber=9	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region GeneratedName OptionType.DatabaseObjectOptions RowNumber=10

            param.Name = "GeneratedName";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Check@Foreign@Index";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "false";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 10;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion GeneratedName OptionType.DatabaseObjectOptions RowNumber=10	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region Precision OptionType.DatabaseObjectOptions RowNumber=11

            param.Name = "Precision";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields@UDT";
            param.ToolTip = "Precision";
            param.Label = "Precision";
            param.ErrorMessage = "Precision ";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 11;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion Precision OptionType.DatabaseObjectOptions RowNumber=11	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region ConstrName OptionType.DatabaseObjectOptions RowNumber=12

            param.Name = "ConstrName";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = string.Empty;
            param.Label = "Constraint name";
            param.ErrorMessage = "Constraint name";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 12;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion ConstrName OptionType.DatabaseObjectOptions RowNumber=12	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region DataTypeName OptionType.DatabaseObjectOptions RowNumber=13

            param.Name = "DataTypeName";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Data type";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 13;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion DataTypeName OptionType.DatabaseObjectOptions RowNumber=13	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsAnsiWarningsEnabled OptionType.DatabaseObjectOptions RowNumber=14

            param.Name = "IsAnsiWarningsEnabled";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Error or warning messages are issued when standard error conditions occur.";
            param.Label = "Ansi warning enabled";
            param.ErrorMessage = "Ansi warning enabled";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 14;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsAnsiWarningsEnabled OptionType.DatabaseObjectOptions RowNumber=14	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region DataBaseLevel OptionType.DatabaseObjectOptions RowNumber=15

            param.Name = "DataBaseLevel";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Compatibility level (60,65,70,80)";
            param.Label = "Compatibility level ";
            param.ErrorMessage = "Compatibility level (60,65,70,80)";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 15;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion DataBaseLevel OptionType.DatabaseObjectOptions RowNumber=15	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region CompareCheck OptionType.DatabaseObjectOptions RowNumber=16

            param.Name = "CompareCheck";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Check constraints";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "True";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 16;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion CompareCheck OptionType.DatabaseObjectOptions RowNumber=16	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsConstraint OptionType.DatabaseObjectOptions RowNumber=17

            param.Name = "IsConstraint";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Index is constraint";
            param.Label = "Constraint";
            param.ErrorMessage = "Constraint";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 17;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsConstraint OptionType.DatabaseObjectOptions RowNumber=17	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region FkeyCnstIsColumn OptionType.DatabaseObjectOptions RowNumber=18

            param.Name = "FkeyCnstIsColumn";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Foreign";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Column constraint";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Constraints/Foreign";
            param.RowNumber = 18;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion FkeyCnstIsColumn OptionType.DatabaseObjectOptions RowNumber=18	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region Text OptionType.DatabaseObjectOptions RowNumber=19

            param.Name = "Text";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Details";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = string.Empty;
            param.RowNumber = 19;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion Text OptionType.DatabaseObjectOptions RowNumber=19	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region FkeyCnstIsDisabled OptionType.DatabaseObjectOptions RowNumber=20

            param.Name = "FkeyCnstIsDisabled";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Foreign";
            param.ToolTip = "Foreing key is disabled";
            param.Label = "Foreing key disabled";
            param.ErrorMessage = "Foreing key disabled";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Constraints/Foreign";
            param.RowNumber = 20;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion FkeyCnstIsDisabled OptionType.DatabaseObjectOptions RowNumber=20	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsPadIndex OptionType.DatabaseObjectOptions RowNumber=21

            param.Name = "IsPadIndex";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Pad index";
            param.Label = "Pad index";
            param.ErrorMessage = "Pad index";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 21;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsPadIndex OptionType.DatabaseObjectOptions RowNumber=21	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IdentSeed OptionType.DatabaseObjectOptions RowNumber=22

            param.Name = "IdentSeed";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Ident seed";
            param.ControlledBy = "IsCompareIdentSeed";
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 22;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IdentSeed OptionType.DatabaseObjectOptions RowNumber=22	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsFulltextEnabled OptionType.DatabaseObjectOptions RowNumber=23

            param.Name = "IsFulltextEnabled";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Database is full-text enabled.";
            param.Label = "Full text enabled";
            param.ErrorMessage = "Full text enabled";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 23;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsFulltextEnabled OptionType.DatabaseObjectOptions RowNumber=23	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region CompareTable OptionType.DatabaseObjectOptions RowNumber=24

            param.Name = "CompareTable";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Tables";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "True";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 24;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion CompareTable OptionType.DatabaseObjectOptions RowNumber=24	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region NoName OptionType.DatabaseObjectOptions RowNumber=25

            param.Name = "NoName";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Check@Foreign@Index";
            param.ToolTip = "Constraint name is generated";
            param.Label = "Name is generated";
            param.ErrorMessage = "No name";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Constraints";
            param.RowNumber = 25;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion NoName OptionType.DatabaseObjectOptions RowNumber=25	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region TableName OptionType.DatabaseObjectOptions RowNumber=26

            param.Name = "TableName";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Check@Fields@Foreign@ForeignKey@Index@IndexKey@Table";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Table name";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 26;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion TableName OptionType.DatabaseObjectOptions RowNumber=26	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region NoRecompute OptionType.DatabaseObjectOptions RowNumber=27

            param.Name = "NoRecompute";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Automatic data-distribution statistics update is performed or not performed.";
            param.Label = "No recompute";
            param.ErrorMessage = "No recompute";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 27;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion NoRecompute OptionType.DatabaseObjectOptions RowNumber=27	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsAnsiPaddingEnabled OptionType.DatabaseObjectOptions RowNumber=28

            param.Name = "IsAnsiPaddingEnabled";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Strings are padded to the same length before comparison or insert";
            param.Label = "Ansi padding enabled";
            param.ErrorMessage = "Ansi padding enabled";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 28;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsAnsiPaddingEnabled OptionType.DatabaseObjectOptions RowNumber=28	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsLastDeleteTrigger OptionType.DatabaseObjectOptions RowNumber=29

            param.Name = "IsLastDeleteTrigger";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Trigger";
            param.ToolTip = "Last delete trigger";
            param.Label = "Last delete trigger";
            param.ErrorMessage = "Last delete trigger";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Procedure, view, function, trigger";
            param.RowNumber = 29;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsLastDeleteTrigger OptionType.DatabaseObjectOptions RowNumber=29	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region DefaultName OptionType.DatabaseObjectOptions RowNumber=30

            param.Name = "DefaultName";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "UDT";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Default name";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "UDT";
            param.RowNumber = 30;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion DefaultName OptionType.DatabaseObjectOptions RowNumber=30	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsIdNotForRepl OptionType.DatabaseObjectOptions RowNumber=31

            param.Name = "IsIdNotForRepl";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = "Id not for replication";
            param.Label = "Id not for replication";
            param.ErrorMessage = "Id not for replication";
            param.ControlledBy = "IsCompareIdentSeed";
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 31;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsIdNotForRepl OptionType.DatabaseObjectOptions RowNumber=31	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsLastUpdateTrigger OptionType.DatabaseObjectOptions RowNumber=32

            param.Name = "IsLastUpdateTrigger";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Trigger";
            param.ToolTip = "Last update trigger";
            param.Label = "Last update trigger";
            param.ErrorMessage = "Last update trigger";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Procedure, view, function, trigger";
            param.RowNumber = 32;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsLastUpdateTrigger OptionType.DatabaseObjectOptions RowNumber=32	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsArithmeticAbortEnabled OptionType.DatabaseObjectOptions RowNumber=33

            param.Name = "IsArithmeticAbortEnabled";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip =
                "Queries are terminated when an overflow or divide-by-zero error occurs during query execution.";
            param.Label = "Arithmetic abort enabled";
            param.ErrorMessage = "Arithmetic abort enabled";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 33;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsArithmeticAbortEnabled OptionType.DatabaseObjectOptions RowNumber=33	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsFirstInsertTrigger OptionType.DatabaseObjectOptions RowNumber=34

            param.Name = "IsFirstInsertTrigger";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Trigger";
            param.ToolTip = "First insert trigger";
            param.Label = "First insert trigger";
            param.ErrorMessage = "First insert trigger";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Procedure, view, function, trigger";
            param.RowNumber = 34;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsFirstInsertTrigger OptionType.DatabaseObjectOptions RowNumber=34	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region DatabaseVersion OptionType.DatabaseObjectOptions RowNumber=35

            param.Name = "DatabaseVersion";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Database internal version";
            param.Label = "Internal version";
            param.ErrorMessage = "Internal version";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 35;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion DatabaseVersion OptionType.DatabaseObjectOptions RowNumber=35	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsAutoShrink OptionType.DatabaseObjectOptions RowNumber=36

            param.Name = "IsAutoShrink";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Database files are candidates for automatic periodic shrinking.";
            param.Label = "Auto shrink";
            param.ErrorMessage = "Auto shrink";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 36;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsAutoShrink OptionType.DatabaseObjectOptions RowNumber=36	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region Id OptionType.DatabaseObjectOptions RowNumber=37

            param.Name = "Id";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Check";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "false";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Constraints/Check";
            param.RowNumber = 37;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion Id OptionType.DatabaseObjectOptions RowNumber=37	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region AllowsNull OptionType.DatabaseObjectOptions RowNumber=38

            param.Name = "AllowsNull";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = "Field is allow null";
            param.Label = "Allow null";
            param.ErrorMessage = "Allows Null";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 38;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion AllowsNull OptionType.DatabaseObjectOptions RowNumber=38	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsRecursiveTriggersEnabled OptionType.DatabaseObjectOptions RowNumber=39

            param.Name = "IsRecursiveTriggersEnabled";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Recursive firing of triggers is enabled.";
            param.Label = "Recursive trigger";
            param.ErrorMessage = "Recursive trigger";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 39;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsRecursiveTriggersEnabled OptionType.DatabaseObjectOptions RowNumber=39	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region RTableName OptionType.DatabaseObjectOptions RowNumber=40

            param.Name = "RTableName";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Foreign";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Reference table";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Constraints/Foreign";
            param.RowNumber = 40;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion RTableName OptionType.DatabaseObjectOptions RowNumber=40	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsRowGuidCol OptionType.DatabaseObjectOptions RowNumber=41

            param.Name = "IsRowGuidCol";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Row GUID";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 41;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsRowGuidCol OptionType.DatabaseObjectOptions RowNumber=41	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region CnsIsDisabled OptionType.DatabaseObjectOptions RowNumber=42

            param.Name = "CnsIsDisabled";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Check";
            param.ToolTip = "Check constraint is disable";
            param.Label = "Constraint disabled";
            param.ErrorMessage = "Disabled constraint";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Constraints/Check";
            param.RowNumber = 42;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion CnsIsDisabled OptionType.DatabaseObjectOptions RowNumber=42	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsMergePublished OptionType.DatabaseObjectOptions RowNumber=43

            param.Name = "IsMergePublished";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "The tables of a database can be published for replication, if replication is installed.";
            param.Label = "Merge published";
            param.ErrorMessage = "Merge published";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 43;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsMergePublished OptionType.DatabaseObjectOptions RowNumber=43	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region Updateability OptionType.DatabaseObjectOptions RowNumber=44

            param.Name = "Updateability";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Indicates whether data can be modified.";
            param.Label = "Database read only";
            param.ErrorMessage = "Indicates whether data can be modified.";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 44;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion Updateability OptionType.DatabaseObjectOptions RowNumber=44	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsComputedText OptionType.DatabaseObjectOptions RowNumber=45

            param.Name = "IsComputedText";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Computed text";
            param.ErrorMessage = "computed text ";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 45;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsComputedText OptionType.DatabaseObjectOptions RowNumber=45	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region UsesDatabaseCollation OptionType.DatabaseObjectOptions RowNumber=46

            param.Name = "UsesDatabaseCollation";
            param.Value = string.Empty;
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Check";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Uses database collation";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "False";
            param.CompareOptionControlType = CompareOptionControlType.TextBox;
            param.UserInterfaceType = string.Empty;
            param.RowNumber = 46;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion UsesDatabaseCollation OptionType.DatabaseObjectOptions RowNumber=46	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsAutoCreateStatistics OptionType.DatabaseObjectOptions RowNumber=47

            param.Name = "IsAutoCreateStatistics";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip =
                "Existing statistics are automatically updated when the statistics become out-of-date because the data in the tables has changed.";
            param.Label = "Auto create statistic";
            param.ErrorMessage = "Auto create statistic";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 47;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsAutoCreateStatistics OptionType.DatabaseObjectOptions RowNumber=47	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region TextFileGroup OptionType.DatabaseObjectOptions RowNumber=48

            param.Name = "TextFileGroup";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Table";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Text file group";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 48;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion TextFileGroup OptionType.DatabaseObjectOptions RowNumber=48	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region TableIsPinned OptionType.DatabaseObjectOptions RowNumber=49

            param.Name = "TableIsPinned";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Table";
            param.ToolTip = "Table is pinned";
            param.Label = "Pinned";
            param.ErrorMessage = "Pinned";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 49;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion TableIsPinned OptionType.DatabaseObjectOptions RowNumber=49	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region TableFullTextBackgroundUpdateIndexOn OptionType.DatabaseObjectOptions RowNumber=50

            param.Name = "TableFullTextBackgroundUpdateIndexOn";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Table";
            param.ToolTip = "Fulltext update";
            param.Label = "Fulltext update";
            param.ErrorMessage = "Fulltext update";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 50;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion TableFullTextBackgroundUpdateIndexOn OptionType.DatabaseObjectOptions RowNumber=50	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsIntegratedSecurityOnly OptionType.DatabaseObjectOptions RowNumber=51

            param.Name = "IsIntegratedSecurityOnly";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Server";
            param.ToolTip = "Windows authentication only";
            param.Label = "Windows authentication only";
            param.ErrorMessage = "Windows authentication only";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Server";
            param.RowNumber = 51;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsIntegratedSecurityOnly OptionType.DatabaseObjectOptions RowNumber=51	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IdxCnstIsDisabled OptionType.DatabaseObjectOptions RowNumber=52

            param.Name = "IdxCnstIsDisabled";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Unique/Primary key disabled";
            param.Label = "Unique/Primary key disabled";
            param.ErrorMessage = "Unique/Primary disabled";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 52;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IdxCnstIsDisabled OptionType.DatabaseObjectOptions RowNumber=52	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsRowLockAllowed OptionType.DatabaseObjectOptions RowNumber=53

            param.Name = "IsRowLockAllowed";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Row lock allowed";
            param.Label = "Row lock allowed";
            param.ErrorMessage = "Row lock allowed";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 53;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsRowLockAllowed OptionType.DatabaseObjectOptions RowNumber=53	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsIndexable OptionType.DatabaseObjectOptions RowNumber=54

            param.Name = "IsIndexable";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = "Is Indexable";
            param.Label = "Is Indexable";
            param.ErrorMessage = "Is Indexable";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 54;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsIndexable OptionType.DatabaseObjectOptions RowNumber=54	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsSubscribed OptionType.DatabaseObjectOptions RowNumber=55

            param.Name = "IsSubscribed";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Database can be subscribed for publication.";
            param.Label = "Subscribed";
            param.ErrorMessage = "Subscribed";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 55;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsSubscribed OptionType.DatabaseObjectOptions RowNumber=55	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region ColId OptionType.DatabaseObjectOptions RowNumber=56

            param.Name = "ColId";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = "Column orders in fields";
            param.Label = "Column order";
            param.ErrorMessage = "Col order";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 56;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion ColId OptionType.DatabaseObjectOptions RowNumber=56	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region RuleName OptionType.DatabaseObjectOptions RowNumber=57

            param.Name = "RuleName";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields@UDT";
            param.ToolTip = "Rule name";
            param.Label = "Rule name";
            param.ErrorMessage = "Rule name";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 57;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion RuleName OptionType.DatabaseObjectOptions RowNumber=57	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsNumericRoundAbortEnabled OptionType.DatabaseObjectOptions RowNumber=58

            param.Name = "IsNumericRoundAbortEnabled";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Errors are generated when loss of precision occurs in expressions.";
            param.Label = "Numeric round abort";
            param.ErrorMessage = "Numeric round abort";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 58;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsNumericRoundAbortEnabled OptionType.DatabaseObjectOptions RowNumber=58	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IgnoreDupKey OptionType.DatabaseObjectOptions RowNumber=59

            param.Name = "IgnoreDupKey";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip =
                "If IGNORE_DUP_KEY was not specified for the unique clustered index, SQL Server issues an error message and rolls back the entire INSERT statement.";
            param.Label = "Ignore duplicate key";
            param.ErrorMessage = "Ignore Duplicate Key";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 59;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IgnoreDupKey OptionType.DatabaseObjectOptions RowNumber=59	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region HasDbAccess OptionType.DatabaseObjectOptions RowNumber=60

            param.Name = "HasDbAccess";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Returns information about whether the user has access to the specified database";
            param.Label = "Has db access";
            param.ErrorMessage = "Has Db Access";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 60;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion HasDbAccess OptionType.DatabaseObjectOptions RowNumber=60	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsSyncWithBackup OptionType.DatabaseObjectOptions RowNumber=61

            param.Name = "IsSyncWithBackup";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Server";
            param.ToolTip = "Any database replicated";
            param.Label = "Any database replicated";
            param.ErrorMessage = "Any database replicated";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Server";
            param.RowNumber = 61;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsSyncWithBackup OptionType.DatabaseObjectOptions RowNumber=61	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region TableTextInRowLimit OptionType.DatabaseObjectOptions RowNumber=62

            param.Name = "TableTextInRowLimit";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Table";
            param.ToolTip = "Text row limit";
            param.Label = "Text row limit";
            param.ErrorMessage = "Text row limit";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 62;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion TableTextInRowLimit OptionType.DatabaseObjectOptions RowNumber=62	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsSqlUser OptionType.DatabaseObjectOptions RowNumber=63

            param.Name = "IsSqlUser";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "User";
            param.ToolTip = "Sql user";
            param.Label = "Sql user";
            param.ErrorMessage = "Sql user";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Users";
            param.RowNumber = 63;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsSqlUser OptionType.DatabaseObjectOptions RowNumber=63	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsAutoClose OptionType.DatabaseObjectOptions RowNumber=64

            param.Name = "IsAutoClose";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Database shuts down cleanly and frees resources after the last user exits.";
            param.Label = "Database auto close";
            param.ErrorMessage = "Database auto close";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 64;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsAutoClose OptionType.DatabaseObjectOptions RowNumber=64	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region KeyNo OptionType.DatabaseObjectOptions RowNumber=65

            param.Name = "KeyNo";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "ForeignKey@IndexKey";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "KeyNo ";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 65;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion KeyNo OptionType.DatabaseObjectOptions RowNumber=65	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IndId OptionType.DatabaseObjectOptions RowNumber=66

            param.Name = "IndId";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index@IndexKey";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "false";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 66;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IndId OptionType.DatabaseObjectOptions RowNumber=66	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region Server OptionType.DatabaseObjectOptions RowNumber=67

            param.Name = "Server";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database@Server";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "false";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Server";
            param.RowNumber = 67;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion Server OptionType.DatabaseObjectOptions RowNumber=67	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsFullTextInstalled OptionType.DatabaseObjectOptions RowNumber=68

            param.Name = "IsFullTextInstalled";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Server";
            param.ToolTip = "Fulltext installed";
            param.Label = "Fulltext installed";
            param.ErrorMessage = "Fulltext installed";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Server";
            param.RowNumber = 68;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsFullTextInstalled OptionType.DatabaseObjectOptions RowNumber=68	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region DefConstrName OptionType.DatabaseObjectOptions RowNumber=69

            param.Name = "DefConstrName";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = "Default constraint name compare if checked  (not recommended)";
            param.Label = "Default constraint name";
            param.ErrorMessage = "Default constraint name";
            param.ControlledBy = "IsCompareDefault";
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 69;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion DefConstrName OptionType.DatabaseObjectOptions RowNumber=69	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IndexFillFactor OptionType.DatabaseObjectOptions RowNumber=70

            param.Name = "IndexFillFactor";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Index fill factor";
            param.Label = "Fillfactor";
            param.ErrorMessage = "Index fill factor";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 70;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IndexFillFactor OptionType.DatabaseObjectOptions RowNumber=70	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsFirstUpdateTrigger OptionType.DatabaseObjectOptions RowNumber=71

            param.Name = "IsFirstUpdateTrigger";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Trigger";
            param.ToolTip = "First update trigger";
            param.Label = "First update trigger";
            param.ErrorMessage = "First update trigger";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Procedure, view, function, trigger";
            param.RowNumber = 71;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsFirstUpdateTrigger OptionType.DatabaseObjectOptions RowNumber=71	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region FkeyCnstIsNotTrusted OptionType.DatabaseObjectOptions RowNumber=72

            param.Name = "FkeyCnstIsNotTrusted";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Foreign";
            param.ToolTip = "Fkey was enabled without checking existing rows, so constraint may not hold for all rows";
            param.Label = "Fkey not trusted";
            param.ErrorMessage = "Fkey was enabled without checking existing rows.";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Constraints/Foreign";
            param.RowNumber = 72;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion FkeyCnstIsNotTrusted OptionType.DatabaseObjectOptions RowNumber=72	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IndexFileGroup OptionType.DatabaseObjectOptions RowNumber=73

            param.Name = "IndexFileGroup";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Index in filegroup";
            param.Label = "Filegroup";
            param.ErrorMessage = "Filegroup";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 73;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IndexFileGroup OptionType.DatabaseObjectOptions RowNumber=73	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region CnsIsNotTrusted OptionType.DatabaseObjectOptions RowNumber=74

            param.Name = "CnsIsNotTrusted";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Check";
            param.ToolTip =
                "Constraint was enabled without checking existing rows, (constraint may not hold for all rows)";
            param.Label = "Constraint not trusted";
            param.ErrorMessage = "Constraint was enabled without checking existing rows.";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Constraints/Check";
            param.RowNumber = 74;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion CnsIsNotTrusted OptionType.DatabaseObjectOptions RowNumber=74	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region ExecIsDeleteTrigger OptionType.DatabaseObjectOptions RowNumber=75

            param.Name = "ExecIsDeleteTrigger";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Trigger";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "false";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "False";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Procedure, view, function, trigger";
            param.RowNumber = 75;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion ExecIsDeleteTrigger OptionType.DatabaseObjectOptions RowNumber=75	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region ExecIsUpdateTrigger OptionType.DatabaseObjectOptions RowNumber=76

            param.Name = "ExecIsUpdateTrigger";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Trigger";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "false";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "False";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Procedure, view, function, trigger";
            param.RowNumber = 76;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion ExecIsUpdateTrigger OptionType.DatabaseObjectOptions RowNumber=76	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsUnique OptionType.DatabaseObjectOptions RowNumber=77

            param.Name = "IsUnique";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Index is unique";
            param.Label = "Index is unique";
            param.ErrorMessage = "Unique";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 77;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsUnique OptionType.DatabaseObjectOptions RowNumber=77	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region TableHasCheckCnst OptionType.DatabaseObjectOptions RowNumber=78

            param.Name = "TableHasCheckCnst";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Table";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "false";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 78;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion TableHasCheckCnst OptionType.DatabaseObjectOptions RowNumber=78	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsFirstDeleteTrigger OptionType.DatabaseObjectOptions RowNumber=79

            param.Name = "IsFirstDeleteTrigger";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Trigger";
            param.ToolTip = "First delete trigger";
            param.Label = "First delete trigger";
            param.ErrorMessage = "First delete trigger";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Procedure, view, function, trigger";
            param.RowNumber = 79;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsFirstDeleteTrigger OptionType.DatabaseObjectOptions RowNumber=79	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsAnsiNullsOn OptionType.DatabaseObjectOptions RowNumber=80

            param.Name = "IsAnsiNullsOn";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Function@Procedure@Trigger@View";
            param.ToolTip = "The setting of ANSI_NULLS at creation time";
            param.Label = "Ansi nulls on";
            param.ErrorMessage = "Ansi nulls";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Procedure, view, function, trigger";
            param.RowNumber = 80;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsAnsiNullsOn OptionType.DatabaseObjectOptions RowNumber=80	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsFulltextIndexed OptionType.DatabaseObjectOptions RowNumber=81

            param.Name = "IsFulltextIndexed";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = "Fields is full text idexed";
            param.Label = string.Empty;
            param.ErrorMessage = "Full text idexed";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 81;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsFulltextIndexed OptionType.DatabaseObjectOptions RowNumber=81	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region ColType OptionType.DatabaseObjectOptions RowNumber=82

            param.Name = "ColType";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = string.Empty;
            param.Label = "Col type";
            param.ErrorMessage = "Col type";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 82;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion ColType OptionType.DatabaseObjectOptions RowNumber=82	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsAnsiNullDefault OptionType.DatabaseObjectOptions RowNumber=83

            param.Name = "IsAnsiNullDefault";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Database follows SQL-92 rules for allowing null values.";
            param.Label = "Ansi default";
            param.ErrorMessage = "Database follows SQL-92 rules for allowing null values.";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 83;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsAnsiNullDefault OptionType.DatabaseObjectOptions RowNumber=83	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region FkeyUpdateCascade OptionType.DatabaseObjectOptions RowNumber=84

            param.Name = "FkeyUpdateCascade";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Foreign";
            param.ToolTip = "A foreign key constraint with the ON UPDATE CASCADE option.";
            param.Label = "Update cascade";
            param.ErrorMessage = "Update cascade";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Constraints/Foreign";
            param.RowNumber = 84;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion FkeyUpdateCascade OptionType.DatabaseObjectOptions RowNumber=84	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsNullConcat OptionType.DatabaseObjectOptions RowNumber=85

            param.Name = "IsNullConcat";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Null concatenation operand yields NULL.";
            param.Label = "Null concat";
            param.ErrorMessage = "Null concat";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 85;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsNullConcat OptionType.DatabaseObjectOptions RowNumber=85	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsAnsiNullsEnabled OptionType.DatabaseObjectOptions RowNumber=86

            param.Name = "IsAnsiNullsEnabled";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "All comparisons to a null evaluate to unknown";
            param.Label = "Ansi nulls enabled";
            param.ErrorMessage = "Ansi nulls enabled";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 86;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsAnsiNullsEnabled OptionType.DatabaseObjectOptions RowNumber=86	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsLocalCursorsDefault OptionType.DatabaseObjectOptions RowNumber=87

            param.Name = "IsLocalCursorsDefault";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Cursor declarations default to LOCAL";
            param.Label = "Cursor declarations default to LOCAL";
            param.ErrorMessage = "Cursor declarations default to LOCAL";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 87;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsLocalCursorsDefault OptionType.DatabaseObjectOptions RowNumber=87	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region Edition OptionType.DatabaseObjectOptions RowNumber=88

            param.Name = "Edition";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Server";
            param.ToolTip = "Sql server edition";
            param.Label = "Sql server edition";
            param.ErrorMessage = "Edition ";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Server";
            param.RowNumber = 88;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion Edition OptionType.DatabaseObjectOptions RowNumber=88	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsAutoUpdateStatistics OptionType.DatabaseObjectOptions RowNumber=89

            param.Name = "IsAutoUpdateStatistics";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Auto update statistics database option is enabled.";
            param.Label = "Auto update statistics";
            param.ErrorMessage = "Auto update statistics";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 89;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsAutoUpdateStatistics OptionType.DatabaseObjectOptions RowNumber=89	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region UserAccess OptionType.DatabaseObjectOptions RowNumber=90

            param.Name = "UserAccess";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Indicates which users can access the database.";
            param.Label = string.Empty;
            param.ErrorMessage = "Indicates which users can access the database.";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 90;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion UserAccess OptionType.DatabaseObjectOptions RowNumber=90	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsClustered OptionType.DatabaseObjectOptions RowNumber=91

            param.Name = "IsClustered";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Index is clustered";
            param.Label = "Clustered";
            param.ErrorMessage = "Clustered";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 91;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsClustered OptionType.DatabaseObjectOptions RowNumber=91	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region ObjectType OptionType.DatabaseObjectOptions RowNumber=92

            param.Name = "ObjectType";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Details";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "False";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = string.Empty;
            param.RowNumber = 92;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion ObjectType OptionType.DatabaseObjectOptions RowNumber=92	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region LoginName OptionType.DatabaseObjectOptions RowNumber=93

            param.Name = "LoginName";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "User";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Login name";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Users";
            param.RowNumber = 93;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion LoginName OptionType.DatabaseObjectOptions RowNumber=93	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region Scale OptionType.DatabaseObjectOptions RowNumber=94

            param.Name = "Scale";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields@UDT";
            param.ToolTip = "Scale ";
            param.Label = "Scale ";
            param.ErrorMessage = "Scale ";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 94;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion Scale OptionType.DatabaseObjectOptions RowNumber=94	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region CnsNotForReplication OptionType.DatabaseObjectOptions RowNumber=95

            param.Name = "CnsNotForReplication";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Check";
            param.ToolTip = "Constraint not for replication";
            param.Label = "Const. not for replication";
            param.ErrorMessage = "Not for replication";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Constraints/Check";
            param.RowNumber = 95;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion CnsNotForReplication OptionType.DatabaseObjectOptions RowNumber=95	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region Fkey OptionType.DatabaseObjectOptions RowNumber=96

            param.Name = "Fkey";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "ForeignKey";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "F.key ";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Constraints/Foreign";
            param.RowNumber = 96;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion Fkey OptionType.DatabaseObjectOptions RowNumber=96	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsLastInsertTrigger OptionType.DatabaseObjectOptions RowNumber=97

            param.Name = "IsLastInsertTrigger";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Trigger";
            param.ToolTip = "Last insert trigger";
            param.Label = "Last insert trigger";
            param.ErrorMessage = "Last insert trigger";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Procedure, view, function, trigger";
            param.RowNumber = 97;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsLastInsertTrigger OptionType.DatabaseObjectOptions RowNumber=97	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region ProcuctVersion OptionType.DatabaseObjectOptions RowNumber=98

            param.Name = "ProcuctVersion";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Server";
            param.ToolTip = "Product version";
            param.Label = "Product version";
            param.ErrorMessage = "Product version";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Server";
            param.RowNumber = 98;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion ProcuctVersion OptionType.DatabaseObjectOptions RowNumber=98	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsCompareIdentSeed OptionType.DatabaseObjectOptions RowNumber=99

            param.Name = "IsCompareIdentSeed";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = "Compare table identity property";
            param.Label = "Compare ident";
            param.ErrorMessage = "Compare ident";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 99;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsCompareIdentSeed OptionType.DatabaseObjectOptions RowNumber=99	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region UsesAnsiTrim OptionType.DatabaseObjectOptions RowNumber=100

            param.Name = "UsesAnsiTrim";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = "Uses ansi trim when table created";
            param.Label = "Ansi trim";
            param.ErrorMessage = "Uses ansi trim when table created";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 100;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion UsesAnsiTrim OptionType.DatabaseObjectOptions RowNumber=100	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region TableHasPrimaryKey OptionType.DatabaseObjectOptions RowNumber=101

            param.Name = "TableHasPrimaryKey";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Table";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "false";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 101;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion TableHasPrimaryKey OptionType.DatabaseObjectOptions RowNumber=101	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsPageLockAllowed OptionType.DatabaseObjectOptions RowNumber=102

            param.Name = "IsPageLockAllowed";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Page lock allowed";
            param.Label = "Page lock dallowed";
            param.ErrorMessage = "Page lock allowed";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 102;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsPageLockAllowed OptionType.DatabaseObjectOptions RowNumber=102	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region FkeyCnstIsNotForReplication OptionType.DatabaseObjectOptions RowNumber=103

            param.Name = "FkeyCnstIsNotForReplication";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Foreign";
            param.ToolTip = "Foreign key not for replication";
            param.Label = "Fkey replication";
            param.ErrorMessage = "Not for replication";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Constraints/Foreign";
            param.RowNumber = 103;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion FkeyCnstIsNotForReplication OptionType.DatabaseObjectOptions RowNumber=103	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region CompareDatabase OptionType.DatabaseObjectOptions RowNumber=104

            param.Name = "CompareDatabase";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Databases";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "True";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 104;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion CompareDatabase OptionType.DatabaseObjectOptions RowNumber=104	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsInStandBy OptionType.DatabaseObjectOptions RowNumber=105

            param.Name = "IsInStandBy";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Database is online as read-only, with restore log allowed.";
            param.Label = "Standby";
            param.ErrorMessage = "Standby";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 105;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsInStandBy OptionType.DatabaseObjectOptions RowNumber=105	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsCompareComments OptionType.DatabaseObjectOptions RowNumber=106

            param.Name = "IsCompareComments";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = "Compare comments in procedures,views,functions,triggers";
            param.Label = "Compare comments";
            param.ErrorMessage = "Compare comments";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 106;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsCompareComments OptionType.DatabaseObjectOptions RowNumber=106	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsTornPageDetectionEnabled OptionType.DatabaseObjectOptions RowNumber=107

            param.Name = "IsTornPageDetectionEnabled";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Detects incomplete I/O operations caused by power failures or other system outages.";
            param.Label = "Torn page detection";
            param.ErrorMessage = "Torn page detection";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 107;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsTornPageDetectionEnabled OptionType.DatabaseObjectOptions RowNumber=107	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region TriggerIsDisabled OptionType.DatabaseObjectOptions RowNumber=108

            param.Name = "TriggerIsDisabled";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Trigger";
            param.ToolTip = "Trigger disabled";
            param.Label = "Trigger disabled";
            param.ErrorMessage = "Trigger disabled";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 108;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion TriggerIsDisabled OptionType.DatabaseObjectOptions RowNumber=108	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region TableFileGroup OptionType.DatabaseObjectOptions RowNumber=109

            param.Name = "TableFileGroup";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Table";
            param.ToolTip = "File group";
            param.Label = "File group";
            param.ErrorMessage = "File group";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 109;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion TableFileGroup OptionType.DatabaseObjectOptions RowNumber=109	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsDescending OptionType.DatabaseObjectOptions RowNumber=110

            param.Name = "IsDescending";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "IndexKey";
            param.ToolTip = "Index key is descending";
            param.Label = "Descending";
            param.ErrorMessage = "Descending";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 110;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsDescending OptionType.DatabaseObjectOptions RowNumber=110	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region Length OptionType.DatabaseObjectOptions RowNumber=111

            param.Name = "Length";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields@UDT";
            param.ToolTip = "Column length";
            param.Label = "Column length";
            param.ErrorMessage = "Column length";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 111;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion Length OptionType.DatabaseObjectOptions RowNumber=111	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region CompareTrigger OptionType.DatabaseObjectOptions RowNumber=112

            param.Name = "CompareTrigger";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Triggers";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "True";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 112;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion CompareTrigger OptionType.DatabaseObjectOptions RowNumber=112	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region CompareIndex OptionType.DatabaseObjectOptions RowNumber=113

            param.Name = "CompareIndex";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Indexes";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "True";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 113;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion CompareIndex OptionType.DatabaseObjectOptions RowNumber=113	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region ColumnName OptionType.DatabaseObjectOptions RowNumber=114

            param.Name = "ColumnName";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "IndexKey";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Column name";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "False";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 114;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion ColumnName OptionType.DatabaseObjectOptions RowNumber=114	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region ExecIsInsertTrigger OptionType.DatabaseObjectOptions RowNumber=115

            param.Name = "ExecIsInsertTrigger";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Trigger";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "false";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "False";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Procedure, view, function, trigger";
            param.RowNumber = 115;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion ExecIsInsertTrigger OptionType.DatabaseObjectOptions RowNumber=115	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region AllowNulls OptionType.DatabaseObjectOptions RowNumber=116

            param.Name = "AllowNulls";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "UDT";
            param.ToolTip = "UDT is allow null";
            param.Label = "Allow null";
            param.ErrorMessage = "allow null";
            param.ControlledBy = "AllowsNull";
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "UDT";
            param.RowNumber = 116;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion AllowNulls OptionType.DatabaseObjectOptions RowNumber=116	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region FkeyDeleteCascade OptionType.DatabaseObjectOptions RowNumber=117

            param.Name = "FkeyDeleteCascade";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Foreign";
            param.ToolTip = "A foreign key constraint with the ON DELETE CASCADE option.";
            param.Label = "Delete cascade";
            param.ErrorMessage = "Delete cascade";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Constraints/Foreign";
            param.RowNumber = 117;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion FkeyDeleteCascade OptionType.DatabaseObjectOptions RowNumber=117	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsQuotedIdentsOn OptionType.DatabaseObjectOptions RowNumber=118

            param.Name = "IsQuotedIdentsOn";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Function@Procedure@Trigger@View";
            param.ToolTip = "Quoted ident";
            param.Label = "Quoted ident";
            param.ErrorMessage = "Quoted ident";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Procedure, view, function, trigger";
            param.RowNumber = 118;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsQuotedIdentsOn OptionType.DatabaseObjectOptions RowNumber=118	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region CompareFunction OptionType.DatabaseObjectOptions RowNumber=119

            param.Name = "CompareFunction";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Functions";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "True";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 119;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion CompareFunction OptionType.DatabaseObjectOptions RowNumber=119	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsIncluded OptionType.DatabaseObjectOptions RowNumber=120

            param.Name = "IsIncluded";
            param.Value = string.Empty;
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "IndexKey";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Included";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "False";
            param.CompareOptionControlType = CompareOptionControlType.TextBox;
            param.UserInterfaceType = string.Empty;
            param.RowNumber = 120;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsIncluded OptionType.DatabaseObjectOptions RowNumber=120	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region RSchema OptionType.DatabaseObjectOptions RowNumber=121

            param.Name = "RSchema";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Foreign";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Reference Schema";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Constraints/Foreign";
            param.RowNumber = 121;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion RSchema OptionType.DatabaseObjectOptions RowNumber=121	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsCloseCursorsOnCommitEnabled OptionType.DatabaseObjectOptions RowNumber=122

            param.Name = "IsCloseCursorsOnCommitEnabled";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Cursors that are open when a transaction is committed are closed.";
            param.Label = "Closer cursor on commit";
            param.ErrorMessage = "Closer cursor on commit";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 122;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsCloseCursorsOnCommitEnabled OptionType.DatabaseObjectOptions RowNumber=122	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsQuotedIdentifiersEnabled OptionType.DatabaseObjectOptions RowNumber=123

            param.Name = "IsQuotedIdentifiersEnabled";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Double quotation marks can be used on identifiers.";
            param.Label = "Quoted identifiers";
            param.ErrorMessage = "Quoted identifiers";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 123;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsQuotedIdentifiersEnabled OptionType.DatabaseObjectOptions RowNumber=123	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region RuleSchema OptionType.DatabaseObjectOptions RowNumber=124

            param.Name = "RuleSchema";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields@UDT";
            param.ToolTip = "Rule schema";
            param.Label = "Rule schema";
            param.ErrorMessage = "Rule schema";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 124;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion RuleSchema OptionType.DatabaseObjectOptions RowNumber=124	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IdentIncr OptionType.DatabaseObjectOptions RowNumber=125

            param.Name = "IdentIncr";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Ident incr";
            param.ControlledBy = "IsCompareIdentSeed";
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 125;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IdentIncr OptionType.DatabaseObjectOptions RowNumber=125	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region TableHasIndex OptionType.DatabaseObjectOptions RowNumber=126

            param.Name = "TableHasIndex";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Table";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "false";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 126;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion TableHasIndex OptionType.DatabaseObjectOptions RowNumber=126	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region ProductLevel OptionType.DatabaseObjectOptions RowNumber=127

            param.Name = "ProductLevel";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Server";
            param.ToolTip = "Product level";
            param.Label = "Product level";
            param.ErrorMessage = "Product level";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Server";
            param.RowNumber = 127;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion ProductLevel OptionType.DatabaseObjectOptions RowNumber=127	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsPrimaryKey OptionType.DatabaseObjectOptions RowNumber=128

            param.Name = "IsPrimaryKey";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = string.Empty;
            param.Label = "Index is primary key";
            param.ErrorMessage = "Primary";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "True";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 128;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsPrimaryKey OptionType.DatabaseObjectOptions RowNumber=128	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region Status OptionType.DatabaseObjectOptions RowNumber=129

            param.Name = "Status";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Database status";
            param.Label = "Database status";
            param.ErrorMessage = "Database status";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 129;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion Status OptionType.DatabaseObjectOptions RowNumber=129	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region ComputedText OptionType.DatabaseObjectOptions RowNumber=130

            param.Name = "ComputedText";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = string.Empty;
            param.Label = "Computed columns text";
            param.ErrorMessage = "Computed text";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 130;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion ComputedText OptionType.DatabaseObjectOptions RowNumber=130	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsFullTextKey OptionType.DatabaseObjectOptions RowNumber=131

            param.Name = "IsFullTextKey";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Full text key";
            param.Label = "Full text key";
            param.ErrorMessage = "Full text key";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 131;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsFullTextKey OptionType.DatabaseObjectOptions RowNumber=131	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region CompareProc OptionType.DatabaseObjectOptions RowNumber=132

            param.Name = "CompareProc";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Procedures";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "True";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 132;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion CompareProc OptionType.DatabaseObjectOptions RowNumber=132	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IdxCnstIsNotTrusted OptionType.DatabaseObjectOptions RowNumber=133

            param.Name = "IdxCnstIsNotTrusted";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Unique/Primary not trusted (not all rows checked)";
            param.Label = "Unique/Primary not trusted";
            param.ErrorMessage = "Not trusted";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 133;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IdxCnstIsNotTrusted OptionType.DatabaseObjectOptions RowNumber=133	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsSchemaBound OptionType.DatabaseObjectOptions RowNumber=134

            param.Name = "IsSchemaBound";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Function@View";
            param.ToolTip = "Schema bound in views and functions";
            param.Label = "Schema bound";
            param.ErrorMessage = "Schema bound";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Procedure, view, function, trigger";
            param.RowNumber = 134;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsSchemaBound OptionType.DatabaseObjectOptions RowNumber=134	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region TableHasUniqueCnst OptionType.DatabaseObjectOptions RowNumber=135

            param.Name = "TableHasUniqueCnst";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Table";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "false";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 135;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion TableHasUniqueCnst OptionType.DatabaseObjectOptions RowNumber=135	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsStartup OptionType.DatabaseObjectOptions RowNumber=136

            param.Name = "IsStartup";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Procedure";
            param.ToolTip = "Procedure exec on startup";
            param.Label = "Exec startup";
            param.ErrorMessage = "Exec startup";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Procedure, view, function, trigger";
            param.RowNumber = 136;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsStartup OptionType.DatabaseObjectOptions RowNumber=136	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region Rkey OptionType.DatabaseObjectOptions RowNumber=137

            param.Name = "Rkey";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "ForeignKey";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "R.key ";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Constraints/Foreign";
            param.RowNumber = 137;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion Rkey OptionType.DatabaseObjectOptions RowNumber=137	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region Name OptionType.DatabaseObjectOptions RowNumber=138

            param.Name = "Name";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName =
                "Check@Database@Default@DefaultCnst@Details@Fields@Foreign@ForeignKey@Function@Index@IndexKey@Procedure@Rule@Server@Trigger@UDT@User@View";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "false";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "False";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = string.Empty;
            param.RowNumber = 138;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion Name OptionType.DatabaseObjectOptions RowNumber=138	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsCompareDefault OptionType.DatabaseObjectOptions RowNumber=139

            param.Name = "IsCompareDefault";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Compare default";
            param.ErrorMessage = "Compare default";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 139;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsCompareDefault OptionType.DatabaseObjectOptions RowNumber=139	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region CompareForeign OptionType.DatabaseObjectOptions RowNumber=140

            param.Name = "CompareForeign";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Foreign keys";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "True";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 140;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion CompareForeign OptionType.DatabaseObjectOptions RowNumber=140	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region DefConstrSchema OptionType.DatabaseObjectOptions RowNumber=141

            param.Name = "DefConstrSchema";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Default constraint schema";
            param.ControlledBy = "IsCompareDefault";
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 141;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion DefConstrSchema OptionType.DatabaseObjectOptions RowNumber=141	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region BaseType OptionType.DatabaseObjectOptions RowNumber=142

            param.Name = "BaseType";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "UDT";
            param.ToolTip = "Compare base type";
            param.Label = "Base type";
            param.ErrorMessage = "base type";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "UDT";
            param.RowNumber = 142;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion BaseType OptionType.DatabaseObjectOptions RowNumber=142	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region RecoveryOption OptionType.DatabaseObjectOptions RowNumber=143

            param.Name = "RecoveryOption";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database";
            param.ToolTip = "Recovery model for the database.";
            param.Label = "Recovery mode";
            param.ErrorMessage = "Recovery mode";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Database";
            param.RowNumber = 143;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion RecoveryOption OptionType.DatabaseObjectOptions RowNumber=143	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region BaseTypeName OptionType.DatabaseObjectOptions RowNumber=144

            param.Name = "BaseTypeName";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = "Compare base type";
            param.Label = "Base type";
            param.ErrorMessage = "Base type";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 144;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion BaseTypeName OptionType.DatabaseObjectOptions RowNumber=144	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region CompareView OptionType.DatabaseObjectOptions RowNumber=145

            param.Name = "CompareView";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Views";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "True";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 145;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion CompareView OptionType.DatabaseObjectOptions RowNumber=145	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsComputed OptionType.DatabaseObjectOptions RowNumber=146

            param.Name = "IsComputed";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = "Computed text field";
            param.Label = "Computed text field";
            param.ErrorMessage = "Computed";
            param.ControlledBy = "IsComputedText";
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 146;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsComputed OptionType.DatabaseObjectOptions RowNumber=146	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region DefaultSchema OptionType.DatabaseObjectOptions RowNumber=147

            param.Name = "DefaultSchema";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "UDT";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Default schema";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "UDT";
            param.RowNumber = 147;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion DefaultSchema OptionType.DatabaseObjectOptions RowNumber=147	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsIdentity OptionType.DatabaseObjectOptions RowNumber=148

            param.Name = "IsIdentity";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = "Is identity";
            param.Label = "Is identity";
            param.ErrorMessage = "Is identity";
            param.ControlledBy = "IsCompareIdentSeed";
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 148;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsIdentity OptionType.DatabaseObjectOptions RowNumber=148	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsSingleUser OptionType.DatabaseObjectOptions RowNumber=149

            param.Name = "IsSingleUser";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Server";
            param.ToolTip = "Single user mod";
            param.Label = "Single user mod";
            param.ErrorMessage = "Single user mod";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Server";
            param.RowNumber = 149;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsSingleUser OptionType.DatabaseObjectOptions RowNumber=149	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region DbName OptionType.DatabaseObjectOptions RowNumber=150

            param.Name = "DbName";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "User";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "db name";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Users";
            param.RowNumber = 150;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion DbName OptionType.DatabaseObjectOptions RowNumber=150	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region Collation OptionType.DatabaseObjectOptions RowNumber=151

            param.Name = "Collation";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Database@Fields@Server";
            param.ToolTip = "You can use different collations";
            param.Label = "Collation (Field,Database,Server)";
            param.ErrorMessage = "Collation ";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 151;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion Collation OptionType.DatabaseObjectOptions RowNumber=151	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region ConstrNameIsGenerated OptionType.DatabaseObjectOptions RowNumber=152

            param.Name = "ConstrNameIsGenerated";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Generated Name";
            param.ControlledBy = "ConstrName";
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 152;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion ConstrNameIsGenerated OptionType.DatabaseObjectOptions RowNumber=152	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region TableHasForeignKey OptionType.DatabaseObjectOptions RowNumber=153

            param.Name = "TableHasForeignKey";
            param.Value = "false";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Table";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "false";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 153;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion TableHasForeignKey OptionType.DatabaseObjectOptions RowNumber=153	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region ConstrSchema OptionType.DatabaseObjectOptions RowNumber=154

            param.Name = "ConstrSchema";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Fields";
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = "Constraint schema";
            param.ControlledBy = "ConstrName";
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Table - field";
            param.RowNumber = 154;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion ConstrSchema OptionType.DatabaseObjectOptions RowNumber=154	CompareOption.CompareOptionParams param = new CompareOption.CompareOptionParams();

            #region IsScriptCollation OptionType.Scripting RowNumber=155

            param.Name = "IsScriptCollation";
            param.Value = "true";
            param.CompareOptionType = OptionType.Scripting;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = string.Empty;
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Scripting options";
            param.RowNumber = 155;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion IsScriptCollation OptionType.Scripting RowNumber=155

            #region CompareServer OptionType.DatabaseObjectOptions RowNumber=156

            param.Name = "CompareServer";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Server property";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "true";
            param.Reload = "true";
            param.Recompare = "true";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 156;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion

            #region CompareServer OptionType.DatabaseObjectOptions RowNumber=157

            param.Name = "CompareUdt";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "User definied types";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "true";
            param.Reload = "true";
            param.Recompare = "true";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 157;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion

            #region CompareServer OptionType.DatabaseObjectOptions RowNumber=158

            param.Name = "CompareSchema";
            param.Value = "true";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = string.Empty;
            param.ToolTip = string.Empty;
            param.Label = "Schema";
            param.ErrorMessage = string.Empty;
            param.ControlledBy = string.Empty;
            param.Visible = "true";
            param.Reload = "true";
            param.Recompare = "true";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "General";
            param.RowNumber = 158;
            this.CompareOptionsList.Add(new CompareOption(param));

            #endregion
            
            /*
             IsDisabled=i.is_disabled,
      HasFilter = i.has_filter,
      FilterDefinition = ISNULL(i.filter_definition,''),
      PartitionSchema = CASE WHEN 'PS' = dsi.type THEN dsi.name ELSE '' END,
      IsXmlIndex = CAST(case when i.type=3 then 1 else 0 end AS bit),
      SecondaryXmlIndex = case UPPER(ISNULL(xi.secondary_type,'')) when 'P' then 1 when 'V' then 2 when 'R' then 3 else 0 END,
      PrimaryXmlIndexName = ISNULL((SELECT  name FROM sys.xml_indexes AS x WHERE xi.OBJECT_ID = x.object_id and  xi.using_xml_index_id = x.index_id AND x.using_xml_index_id IS null),'')
             */

            #region IsDisabled
            param.Name = "IsDisabled";
            param.Value = "True";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Index is disabled";
            param.Label = "Index is disabled";
            param.ErrorMessage = "Index is disabled";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 159;
            this.CompareOptionsList.Add(new CompareOption(param));
            #endregion

            #region HasFilter
            param.Name = "HasFilter";
            param.Value = "True";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Index has filter";
            param.Label = "Index has filter";
            param.ErrorMessage = "Index filter";
            param.ControlledBy = string.Empty;
            param.Visible = "False";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 160;
            this.CompareOptionsList.Add(new CompareOption(param));
            #endregion

            #region FilterDefinition
            param.Name = "FilterDefinition";
            param.Value = "True";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Index filter";
            param.Label = "Index filter";
            param.ErrorMessage = "Index filter";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 161;
            this.CompareOptionsList.Add(new CompareOption(param));
            #endregion

            #region IsXmlIndex
            param.Name = "IsXmlIndex";
            param.Value = "True";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Index is xml index";
            param.Label = "Index is xml index";
            param.ErrorMessage = "Index xml index";
            param.ControlledBy = string.Empty;
            param.Visible = "false";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 162;
            this.CompareOptionsList.Add(new CompareOption(param));
            #endregion

            #region PartitionSchema
            param.Name = "PartitionSchema";
            param.Value = "True";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Partition Schema";
            param.Label = "Partition Schema";
            param.ErrorMessage = "Partition Schema";
            param.ControlledBy = string.Empty;
            param.Visible = "True";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 163;
            this.CompareOptionsList.Add(new CompareOption(param));
            #endregion

            #region SecondaryXmlIndex
            param.Name = "SecondaryXmlIndex";
            param.Value = "True";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Secondary Xml Index";
            param.Label = "Secondary Xml Index";
            param.ErrorMessage = "Secondary Xml Index";
            param.ControlledBy = string.Empty;
            param.Visible = "false";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 164;
            this.CompareOptionsList.Add(new CompareOption(param));
            #endregion

            #region PrimaryXmlIndexName
            param.Name = "PrimaryXmlIndexName";
            param.Value = "True";
            param.CompareOptionType = OptionType.DatabaseObjectOptions;
            param.ErrorMsgId = string.Empty;
            param.TableName = "Index";
            param.ToolTip = "Primary Xml Index Name";
            param.Label = "Primary Xml Index name";
            param.ErrorMessage = "Primary Xml Index name";
            param.ControlledBy = string.Empty;
            param.Visible = "false";
            param.Reload = "False";
            param.Recompare = "True";
            param.CompareOptionControlType = CompareOptionControlType.CheckBox;
            param.UserInterfaceType = "Index";
            param.RowNumber = 165;
            this.CompareOptionsList.Add(new CompareOption(param));
            #endregion

        }

        /// <summary>
        /// The get compare option bool value.
        /// </summary>
        /// <param name="optionName">
        /// The option name.
        /// </param>
        /// <returns>
        /// Returs compare option bool value.
        /// </returns>
        /// <exception cref="ApplicationException">
        /// </exception>
        /// <exception cref="ApplicationException">
        /// </exception>
        public bool GetCompareOptionBoolValue(string optionName)
        {
            int i = this.CompareOptionsList.FindIndex(z => z.Name == optionName);

            if (i <= -1)
            {
                throw new ApplicationException(string.Format("ERROR: Invalid compare option! Option name: {0}", optionName));
            }
            
            string compareOptionValue = this.CompareOptionsList[i].Value.ToLower();
            if ((compareOptionValue.ToLower() != "true") && (compareOptionValue.ToLower() != "false"))
            {
                throw new ApplicationException(string.Format("ERROR: Compare option value is not boolean! Option name: {0}", optionName));
            }

            return this.CompareOptionsList[i].Value.ToLower() == "true";
        }

        /// <summary>
        /// The get compare option value.
        /// </summary>
        /// <param name="optionName">
        /// The option name.
        /// </param>
        /// <returns>
        /// Returns compare option value.
        /// </returns>
        /// <exception cref="ApplicationException">
        /// </exception>
        public string GetCompareOptionValue(string optionName)
        {
            int i = this.CompareOptionsList.FindIndex(z => z.Name == optionName);
            if (i > -1)
            {
                return this.CompareOptionsList[i].Value;
            }

            throw new ApplicationException(string.Format("ERROR: Invalid compare option! Option name: {0}", optionName));
        }
    }
}
